Pandas Profiling Report

Dataset statistics

Number of variables	72
Number of observations	837766
Missing cells	43832259
Missing cells (%)	72.7%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	460.2 MiB
Average record size in memory	576.0 B

Variable types

CAT	31
BOOL	22
NUM	11
UNSUPPORTED	8

Reproduction

Analysis started	2020-07-05 20:46:27.042288
Analysis finished	2020-07-05 20:51:51.733062
Duration	5 minutes and 24.69 seconds
Version	pandas-profiling v2.8.0
Command line	`pandas_profiling --config_file config.yaml [YOUR_FILE.csv]`
Download configuration	config.yaml

Warnings

`CRASH_RECORD_ID` has a high cardinality: 414426 distinct values	High cardinality
`RD_NO` has a high cardinality: 410659 distinct values	High cardinality
`CRASH_DATE` has a high cardinality: 268332 distinct values	High cardinality
`MAKE` has a high cardinality: 909 distinct values	High cardinality
`MODEL` has a high cardinality: 2143 distinct values	High cardinality
`LIC_PLATE_STATE` has a high cardinality: 52 distinct values	High cardinality
`TOWED_BY` has a high cardinality: 7298 distinct values	High cardinality
`TOWED_TO` has a high cardinality: 7702 distinct values	High cardinality
`CARRIER_NAME` has a high cardinality: 5945 distinct values	High cardinality
`CARRIER_CITY` has a high cardinality: 1443 distinct values	High cardinality
`VEHICLE_ID` is highly correlated with `CRASH_UNIT_ID` and 1 other fields	High correlation
`CRASH_UNIT_ID` is highly correlated with `VEHICLE_ID` and 1 other fields	High correlation
`OCCUPANT_CNT` is highly correlated with `NUM_PASSENGERS`	High correlation
`NUM_PASSENGERS` is highly correlated with `OCCUPANT_CNT`	High correlation
`CMV_ID` is highly correlated with `CRASH_UNIT_ID` and 1 other fields	High correlation
`NUM_PASSENGERS` has 718762 (85.8%) missing values	Missing
`VEHICLE_ID` has 17454 (2.1%) missing values	Missing
`CMRC_VEH_I` has 822260 (98.1%) missing values	Missing
`MAKE` has 17485 (2.1%) missing values	Missing
`MODEL` has 19418 (2.3%) missing values	Missing
`LIC_PLATE_STATE` has 84715 (10.1%) missing values	Missing
`VEHICLE_YEAR` has 148417 (17.7%) missing values	Missing
`VEHICLE_DEFECT` has 17454 (2.1%) missing values	Missing
`VEHICLE_TYPE` has 17454 (2.1%) missing values	Missing
`VEHICLE_USE` has 17454 (2.1%) missing values	Missing
`TRAVEL_DIRECTION` has 17454 (2.1%) missing values	Missing
`MANEUVER` has 17454 (2.1%) missing values	Missing
`TOWED_I` has 749549 (89.5%) missing values	Missing
`FIRE_I` has 837249 (99.9%) missing values	Missing
`OCCUPANT_CNT` has 17454 (2.1%) missing values	Missing
`EXCEED_SPEED_LIMIT_I` has 835407 (99.7%) missing values	Missing
`TOWED_BY` has 773923 (92.4%) missing values	Missing
`TOWED_TO` has 797332 (95.2%) missing values	Missing
`AREA_00_I` has 803547 (95.9%) missing values	Missing
`AREA_01_I` has 621754 (74.2%) missing values	Missing
`AREA_02_I` has 687809 (82.1%) missing values	Missing
`AREA_03_I` has 757701 (90.4%) missing values	Missing
`AREA_04_I` has 751174 (89.7%) missing values	Missing
`AREA_05_I` has 708242 (84.5%) missing values	Missing
`AREA_06_I` has 714831 (85.3%) missing values	Missing
`AREA_07_I` has 734840 (87.7%) missing values	Missing
`AREA_08_I` has 686559 (82.0%) missing values	Missing
`AREA_09_I` has 812559 (97.0%) missing values	Missing
`AREA_10_I` has 800564 (95.6%) missing values	Missing
`AREA_11_I` has 763625 (91.2%) missing values	Missing
`AREA_12_I` has 765460 (91.4%) missing values	Missing
`AREA_99_I` has 751710 (89.7%) missing values	Missing
`FIRST_CONTACT_POINT` has 21456 (2.6%) missing values	Missing
`CMV_ID` has 828732 (98.9%) missing values	Missing
`USDOT_NO` has 832468 (99.4%) missing values	Missing
`CCMC_NO` has 836608 (99.9%) missing values	Missing
`ILCC_NO` has 836909 (99.9%) missing values	Missing
`COMMERCIAL_SRC` has 831185 (99.2%) missing values	Missing
`GVWR` has 832521 (99.4%) missing values	Missing
`CARRIER_NAME` has 829095 (99.0%) missing values	Missing
`CARRIER_STATE` has 829541 (99.0%) missing values	Missing
`CARRIER_CITY` has 829690 (99.0%) missing values	Missing
`HAZMAT_PLACARDS_I` has 837586 (> 99.9%) missing values	Missing
`HAZMAT_NAME` has 837733 (> 99.9%) missing values	Missing
`UN_NO` has 837430 (> 99.9%) missing values	Missing
`HAZMAT_PRESENT_I` has 831130 (99.2%) missing values	Missing
`HAZMAT_REPORT_I` has 831337 (99.2%) missing values	Missing
`HAZMAT_REPORT_NO` has 837766 (100.0%) missing values	Missing
`MCS_REPORT_I` has 831288 (99.2%) missing values	Missing
`MCS_REPORT_NO` has 837761 (> 99.9%) missing values	Missing
`HAZMAT_VIO_CAUSE_CRASH_I` has 831236 (99.2%) missing values	Missing
`MCS_VIO_CAUSE_CRASH_I` has 831330 (99.2%) missing values	Missing
`IDOT_PERMIT_NO` has 837227 (99.9%) missing values	Missing
`WIDE_LOAD_I` has 837692 (> 99.9%) missing values	Missing
`TRAILER1_WIDTH` has 835808 (99.8%) missing values	Missing
`TRAILER2_WIDTH` has 837544 (> 99.9%) missing values	Missing
`TRAILER1_LENGTH` has 836152 (99.8%) missing values	Missing
`TRAILER2_LENGTH` has 837721 (> 99.9%) missing values	Missing
`TOTAL_VEHICLE_LENGTH` has 835813 (99.8%) missing values	Missing
`AXLE_CNT` has 835049 (99.7%) missing values	Missing
`VEHICLE_CONFIG` has 830224 (99.1%) missing values	Missing
`CARGO_BODY_TYPE` has 830540 (99.1%) missing values	Missing
`LOAD_TYPE` has 830854 (99.2%) missing values	Missing
`HAZMAT_OUT_OF_SERVICE_I` has 831529 (99.3%) missing values	Missing
`MCS_OUT_OF_SERVICE_I` has 831353 (99.2%) missing values	Missing
`HAZMAT_CLASS` has 837151 (99.9%) missing values	Missing
`VEHICLE_YEAR` is highly skewed (γ1 = 49.02841634)	Skewed
`AXLE_CNT` is highly skewed (γ1 = 52.12198557)	Skewed
`CRASH_RECORD_ID` is uniformly distributed	Uniform
`RD_NO` is uniformly distributed	Uniform
`CRASH_UNIT_ID` has unique values	Unique
`USDOT_NO` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`CCMC_NO` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`ILCC_NO` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`GVWR` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`UN_NO` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`HAZMAT_REPORT_NO` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`MCS_REPORT_NO` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`IDOT_PERMIT_NO` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`OCCUPANT_CNT` has 102317 (12.2%) zeros	Zeros

CRASH_UNIT_ID
Real number (ℝ_≥0)

HIGH CORRELATION
UNIQUE

Distinct count	837766
Unique (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	450031.11142252135
Minimum	2
Maximum	910029
Zeros	0
Zeros (%)	0.0%
Memory size	6.4 MiB

Quantile statistics

Minimum	2
5-th percentile	43754.25
Q1	220128.25
median	447564.5
Q3	678641.75
95-th percentile	863177.75
Maximum	910029
Range	910027
Interquartile range (IQR)	458513.5

Descriptive statistics

Standard deviation	263542.9848
Coefficient of variation (CV)	0.5856105902
Kurtosis	-1.208981022
Mean	450031.1114
Median Absolute Deviation (MAD)	229218.5
Skewness	0.0220150255
Sum	3.770207641e+11
Variance	6.945490482e+10

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
2047	1	< 0.1%
665616	1	< 0.1%
684059	1	< 0.1%
686106	1	< 0.1%
682008	1	< 0.1%
659479	1	< 0.1%
661526	1	< 0.1%
655381	1	< 0.1%
657428	1	< 0.1%
667667	1	< 0.1%
Other values (837756)	837756	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%

Value	Count	Frequency (%)
910029	1	< 0.1%
910028	1	< 0.1%
910021	1	< 0.1%
910020	1	< 0.1%
910019	1	< 0.1%

CRASH_RECORD_ID
Categorical

HIGH CARDINALITY
UNIFORM

Distinct count	414426
Unique (%)	49.5%
Missing	0
Missing (%)	0.0%
Memory size	6.4 MiB

e4f07da854d2b7be0c4c0903296e6f1a1f0109ddebca9d5b5dc399ffc698f2118f0f658ad5b1e3559714e0a3e2550720e3cb88e9753ce9a93ca3a20fa553fed7	18
fb8d94334f5987710b7aa9cb4b0302f8e4c8f5f6e6d9f50ff0502a143737b3bfe95c37d970bcab190390797ad5c8fb6a9b6909f73186488c9b91267a4b844c65	16
d128ebe105ed99a8372e21acc70d596bf4a64b28249e679ba33d4b450db5dba4621aa305e5e3cc8e31cab1beebf75645b34211d4dbbb434e5fb7d142c2569870	15
6485b8f4e89d7685abf38d22d3017003234343937ca227e63c5a20b17903a860917a4bbd523f716f1b926d551a25eaedcb61994139ff8fa4acbec2e7550722a4	12
c2430f71beeeefd0a59b1c3e56e57c11f0a7ab04d90b1842d3cc726834ee65a94791bc13ef191959200e0ba1e07a9fce38e5b2d834858d3cf816c4c40de29961	12
Other values (414421)	837693

Common Values
Length

Value	Count	Frequency (%)
e4f07da854d2b7be0c4c0903296e6f1a1f0109ddebca9d5b5dc399ffc698f2118f0f658ad5b1e3559714e0a3e2550720e3cb88e9753ce9a93ca3a20fa553fed7	18	< 0.1%
fb8d94334f5987710b7aa9cb4b0302f8e4c8f5f6e6d9f50ff0502a143737b3bfe95c37d970bcab190390797ad5c8fb6a9b6909f73186488c9b91267a4b844c65	16	< 0.1%
d128ebe105ed99a8372e21acc70d596bf4a64b28249e679ba33d4b450db5dba4621aa305e5e3cc8e31cab1beebf75645b34211d4dbbb434e5fb7d142c2569870	15	< 0.1%
6485b8f4e89d7685abf38d22d3017003234343937ca227e63c5a20b17903a860917a4bbd523f716f1b926d551a25eaedcb61994139ff8fa4acbec2e7550722a4	12	< 0.1%
c2430f71beeeefd0a59b1c3e56e57c11f0a7ab04d90b1842d3cc726834ee65a94791bc13ef191959200e0ba1e07a9fce38e5b2d834858d3cf816c4c40de29961	12	< 0.1%
c9ea6db6a3665f9828881fc7c297f4967a76e059aac1622ec859780f626b40ffaf2ee0f78c87f49434ffec3e991ea9d543be0e8d85406a5215c518e76482b499	11	< 0.1%
94ec1a051bc04155dc7b2be57e480b27908bc41b4a2eca60e887a21ab9f648e542e30046af9ef139c7a6720d4ff523403d6ce3c3cc244ec1dad63765c657ad5c	11	< 0.1%
c1af6a8bcc100b6cd5a2c7c43adcdfba9e76a029ed1f7a0235a139a55428d3443a32d3c98c58498243370a230ff9031e42619a524519619f27d69e4cfa2edfee	11	< 0.1%
f4d195b55b5f6541f9e29125d1c1599bf7980fcdfb2ff1b4d99c1a5d2d8faca86bf10824f3071f17cf7e773469bed11ed359b65e83486c8cabecd9276c151850	10	< 0.1%
182f2fe6a3f75b93ca4589a8578548b7e4bdef14cafd1039386386daa3c74c4b0b1f7c7d1d7b3e3db0b27db3ecbe8fa30d4990b197702623b088f2f1bc35793b	10	< 0.1%
Other values (414416)	837640	> 99.9%

Length

Max length	128
Median length	128
Mean length	128
Min length	128

RD_NO
Categorical

HIGH CARDINALITY
UNIFORM

Distinct count	410659
Unique (%)	49.5%
Missing	7719
Missing (%)	0.9%
Memory size	6.4 MiB

JB311558	18
JB330122	16
JD141706	15
JB530190	12
JC406074	12
Other values (410654)	829974

Common Values
Length

Value	Count	Frequency (%)
JB311558	18	< 0.1%
JB330122	16	< 0.1%
JD141706	15	< 0.1%
JB530190	12	< 0.1%
JC406074	12	< 0.1%
JD223633	11	< 0.1%
JA553317	11	< 0.1%
JC164705	11	< 0.1%
JA522872	10	< 0.1%
JD100146	10	< 0.1%
Other values (410649)	829921	99.1%
(Missing)	7719	0.9%

Length

Max length	8
Median length	8
Mean length	7.95393105
Min length	3

CRASH_DATE
Categorical

HIGH CARDINALITY

Distinct count	268332
Unique (%)	32.0%
Missing	0
Missing (%)	0.0%
Memory size	6.4 MiB

11/10/2017 10:30:00 AM	58
11/10/2017 10:00:00 AM	41
01/12/2019 02:30:00 PM	39
01/12/2019 02:00:00 PM	38
01/12/2019 03:00:00 PM	37
Other values (268327)	837553

Common Values
Length

Value	Count	Frequency (%)
11/10/2017 10:30:00 AM	58	< 0.1%
11/10/2017 10:00:00 AM	41	< 0.1%
01/12/2019 02:30:00 PM	39	< 0.1%
01/12/2019 02:00:00 PM	38	< 0.1%
01/12/2019 03:00:00 PM	37	< 0.1%
02/26/2020 07:45:00 AM	35	< 0.1%
02/26/2020 08:00:00 AM	32	< 0.1%
09/04/2018 08:00:00 AM	32	< 0.1%
01/12/2019 04:00:00 PM	31	< 0.1%
10/10/2018 03:30:00 PM	31	< 0.1%
Other values (268322)	837392	> 99.9%

Length

Max length	22
Median length	22
Mean length	22
Min length	22

UNIT_NO
Real number (ℝ_≥0)

Distinct count	19
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1.555990574933812
Minimum	0
Maximum	18
Zeros	11
Zeros (%)	< 0.1%
Memory size	6.4 MiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
median	2
Q3	2
95-th percentile	2
Maximum	18
Range	18
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.6210063601
Coefficient of variation (CV)	0.399106762
Kurtosis	10.3017416
Mean	1.555990575
Median Absolute Deviation (MAD)	1
Skewness	1.516570025
Sum	1303556
Variance	0.3856488993

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1	414038	49.4%
2	391615	46.7%
3	25346	3.0%
4	4840	0.6%
5	1238	0.1%
6	386	< 0.1%
7	154	< 0.1%
8	61	< 0.1%
9	33	< 0.1%
10	18	< 0.1%
Other values (9)	37	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	11	< 0.1%
1	414038	49.4%
2	391615	46.7%
3	25346	3.0%
4	4840	0.6%

Value	Count	Frequency (%)
18	1	< 0.1%
17	1	< 0.1%
16	2	< 0.1%
15	3	< 0.1%
14	3	< 0.1%

UNIT_TYPE
Categorical

Distinct count	9
Unique (%)	< 0.1%
Missing	11
Missing (%)	< 0.1%
Memory size	6.4 MiB

DRIVER	709212
PARKED	103314
PEDESTRIAN	10564
DRIVERLESS	7667
BICYCLE	6044
Other values (4)	954

Common Values
Length

Value	Count	Frequency (%)
DRIVER	709212	84.7%
PARKED	103314	12.3%
PEDESTRIAN	10564	1.3%
DRIVERLESS	7667	0.9%
BICYCLE	6044	0.7%
NON-MOTOR VEHICLE	759	0.1%
NON-CONTACT VEHICLE	161	< 0.1%
DISABLED VEHICLE	29	< 0.1%
EQUESTRIAN	5	< 0.1%
(Missing)	11	< 0.1%

Length

Max length	19
Median length	6
Mean length	6.107054953
Min length	3

NUM_PASSENGERS
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct count	40
Unique (%)	< 0.1%
Missing	718762
Missing (%)	85.8%
Infinite	0
Infinite (%)	0.0%

Mean	1.4887650835266042
Minimum	1.0
Maximum	59.0
Zeros	0
Zeros (%)	0.0%
Memory size	6.4 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	2
95-th percentile	3
Maximum	59
Range	58
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.114858585
Coefficient of variation (CV)	0.7488478859
Kurtosis	296.1777592
Mean	1.488765084
Median Absolute Deviation (MAD)	0
Skewness	10.89489652
Sum	177169
Variance	1.242909665

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1	83189	9.9%
2	22511	2.7%
3	8880	1.1%
4	2913	0.3%
5	794	0.1%
6	301	< 0.1%
7	124	< 0.1%
8	66	< 0.1%
10	42	< 0.1%
9	36	< 0.1%
Other values (30)	148	< 0.1%
(Missing)	718762	85.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	83189	9.9%
2	22511	2.7%
3	8880	1.1%
4	2913	0.3%
5	794	0.1%

Value	Count	Frequency (%)
59	1	< 0.1%
46	1	< 0.1%
43	2	< 0.1%
42	1	< 0.1%
40	2	< 0.1%

VEHICLE_ID
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct count	820312
Unique (%)	100.0%
Missing	17454
Missing (%)	2.1%
Infinite	0
Infinite (%)	0.0%

Mean	429604.923371839
Minimum	2.0
Maximum	862791.0
Zeros	0
Zeros (%)	0.0%
Memory size	6.4 MiB

Quantile statistics

Minimum	2
5-th percentile	41829.55
Q1	214449.75
median	428156
Q3	645274.25
95-th percentile	819137.45
Maximum	862791
Range	862789
Interquartile range (IQR)	430824.5

Descriptive statistics

Standard deviation	249060.5324
Coefficient of variation (CV)	0.5797431987
Kurtosis	-1.197315586
Mean	429604.9234
Median Absolute Deviation (MAD)	215405.5
Skewness	0.008884082005
Sum	3.524100739e+11
Variance	6.203114882e+10

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
131071	1	< 0.1%
396041	1	< 0.1%
396049	1	< 0.1%
24753	1	< 0.1%
833904	1	< 0.1%
396047	1	< 0.1%
396046	1	< 0.1%
396045	1	< 0.1%
833905	1	< 0.1%
596784	1	< 0.1%
Other values (820302)	820302	97.9%
(Missing)	17454	2.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%

Value	Count	Frequency (%)
862791	1	< 0.1%
862789	1	< 0.1%
862782	1	< 0.1%
862780	1	< 0.1%
862779	1	< 0.1%

CMRC_VEH_I
Boolean

MISSING

Distinct count	2
Unique (%)	< 0.1%
Missing	822260
Missing (%)	98.1%
Memory size	6.4 MiB

Y	10472
N	5034
(Missing)	822260

Frequency Table

Value	Count	Frequency (%)
Y	10472	1.2%
N	5034	0.6%
(Missing)	822260	98.1%

MAKE
Categorical

HIGH CARDINALITY
MISSING

Distinct count	909
Unique (%)	0.1%
Missing	17485
Missing (%)	2.1%
Memory size	6.4 MiB

CHEVROLET	96438
TOYOTA MOTOR COMPANY, LTD.	87868
FORD	81836
UNKNOWN	80394
NISSAN	67980
Other values (904)	405765

Common Values
Length

Value	Count	Frequency (%)
CHEVROLET	96438	11.5%
TOYOTA MOTOR COMPANY, LTD.	87868	10.5%
FORD	81836	9.8%
UNKNOWN	80394	9.6%
NISSAN	67980	8.1%
HONDA	58756	7.0%
DODGE	37643	4.5%
HYUNDAI	33804	4.0%
JEEP	30975	3.7%
KIA MOTORS CORP	17279	2.1%
Other values (899)	227308	27.1%
(Missing)	17485	2.1%

Length

Max length	60
Median length	7
Mean length	9.355866674
Min length	2

MODEL
Categorical

HIGH CARDINALITY
MISSING

Distinct count	2143
Unique (%)	0.3%
Missing	19418
Missing (%)	2.3%
Memory size	6.4 MiB

UNKNOWN	177577
CAMRY	28533
NISSAN ALTIMA	17478
COROLLA	16570
CIVIC	15808
Other values (2138)	562382

Common Values
Length

Value	Count	Frequency (%)
UNKNOWN	177577	21.2%
CAMRY	28533	3.4%
NISSAN ALTIMA	17478	2.1%
COROLLA	16570	2.0%
CIVIC	15808	1.9%
ACCORD	14530	1.7%
MALIBU (CHEVELLE)	14206	1.7%
IMPALA	12723	1.5%
SENTRA (DATSUN AND NISSAN HAVE MERGED)	10925	1.3%
ELANTRA	9567	1.1%
Other values (2133)	500431	59.7%
(Missing)	19418	2.3%

Length

Max length	60
Median length	7
Mean length	8.802459159
Min length	2

LIC_PLATE_STATE
Categorical

HIGH CARDINALITY
MISSING

Distinct count	52
Unique (%)	< 0.1%
Missing	84715
Missing (%)	10.1%
Memory size	6.4 MiB

IL	686212
XX	23167
IN	13947
WI	4568
MI	3335
Other values (47)	21822

Common Values
Length

Value	Count	Frequency (%)
IL	686212	81.9%
XX	23167	2.8%
IN	13947	1.7%
WI	4568	0.5%
MI	3335	0.4%
FL	1934	0.2%
TX	1900	0.2%
OH	1842	0.2%
AZ	1582	0.2%
IA	1343	0.2%
Other values (42)	13221	1.6%
(Missing)	84715	10.1%

Length

Max length	3
Median length	2
Mean length	2.101120122
Min length	2

VEHICLE_YEAR
Real number (ℝ_≥0)

MISSING
SKEWED

Distinct count	169
Unique (%)	< 0.1%
Missing	148417
Missing (%)	17.7%
Infinite	0
Infinite (%)	0.0%

Mean	2013.4487886397167
Minimum	1900.0
Maximum	9999.0
Zeros	0
Zeros (%)	0.0%
Memory size	6.4 MiB

Quantile statistics

Minimum	1900
5-th percentile	1999
Q1	2006
median	2011
Q3	2015
95-th percentile	2018
Maximum	9999
Range	8099
Interquartile range (IQR)	9

Descriptive statistics

Standard deviation	160.9657609
Coefficient of variation (CV)	0.07994529675
Kurtosis	2421.532809
Mean	2013.448789
Median Absolute Deviation (MAD)	4
Skewness	49.02841634
Sum	1387968909
Variance	25909.97618

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
2015	56590	6.8%
2016	51813	6.2%
2014	50476	6.0%
2013	46013	5.5%
2017	45718	5.5%
2012	39799	4.8%
2007	35833	4.3%
2008	34173	4.1%
2011	33197	4.0%
2006	32213	3.8%
Other values (159)	263524	31.5%
(Missing)	148417	17.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1900	169	< 0.1%
1901	11	< 0.1%
1905	1	< 0.1%
1911	1	< 0.1%
1920	1	< 0.1%

Value	Count	Frequency (%)
9999	274	< 0.1%
9900	1	< 0.1%
7999	1	< 0.1%
7007	1	< 0.1%
6414	2	< 0.1%

VEHICLE_DEFECT
Categorical

MISSING

Distinct count	17
Unique (%)	< 0.1%
Missing	17454
Missing (%)	2.1%
Memory size	6.4 MiB

NONE	488521
UNKNOWN	323473
OTHER	4124
BRAKES	2754
TIRES	382
Other values (12)	1058

Common Values
Length

Value	Count	Frequency (%)
NONE	488521	58.3%
UNKNOWN	323473	38.6%
OTHER	4124	0.5%
BRAKES	2754	0.3%
TIRES	382	< 0.1%
STEERING	340	< 0.1%
WHEELS	204	< 0.1%
SUSPENSION	117	< 0.1%
ENGINE/MOTOR	100	< 0.1%
FUEL SYSTEM	97	< 0.1%
Other values (7)	200	< 0.1%
(Missing)	17454	2.1%

Length

Max length	16
Median length	4
Mean length	5.155025389
Min length	3

VEHICLE_TYPE
Categorical

MISSING

Distinct count	22
Unique (%)	< 0.1%
Missing	17454
Missing (%)	2.1%
Memory size	6.4 MiB

PASSENGER	520253
SPORT UTILITY VEHICLE (SUV)	105952
UNKNOWN/NA	77127
VAN/MINI-VAN	42940
PICKUP	23834
Other values (17)	50206

Common Values
Length

Value	Count	Frequency (%)
PASSENGER	520253	62.1%
SPORT UTILITY VEHICLE (SUV)	105952	12.6%
UNKNOWN/NA	77127	9.2%
VAN/MINI-VAN	42940	5.1%
PICKUP	23834	2.8%
TRUCK - SINGLE UNIT	16052	1.9%
BUS OVER 15 PASS.	9474	1.1%
OTHER	9202	1.1%
TRACTOR W/ SEMI-TRAILER	7951	0.9%
MOTORCYCLE (OVER 150CC)	1742	0.2%
Other values (12)	5785	0.7%
(Missing)	17454	2.1%

Length

Max length	38
Median length	9
Mean length	11.79868006
Min length	3

VEHICLE_USE
Categorical

MISSING

Distinct count	25
Unique (%)	< 0.1%
Missing	17454
Missing (%)	2.1%
Memory size	6.4 MiB

PERSONAL	533170
UNKNOWN/NA	156172
NOT IN USE	39870
OTHER	25390
TAXI/FOR HIRE	15908
Other values (20)	49802

Common Values
Length

Value	Count	Frequency (%)
PERSONAL	533170	63.6%
UNKNOWN/NA	156172	18.6%
NOT IN USE	39870	4.8%
OTHER	25390	3.0%
TAXI/FOR HIRE	15908	1.9%
COMMERCIAL - SINGLE UNIT	10841	1.3%
RIDESHARE SERVICE	8312	1.0%
CTA	5496	0.7%
POLICE	5338	0.6%
OTHER TRANSIT	3937	0.5%
Other values (15)	15878	1.9%
(Missing)	17454	2.1%

Length

Max length	28
Median length	8
Mean length	8.805004023
Min length	3

TRAVEL_DIRECTION
Categorical

MISSING

Distinct count	9
Unique (%)	< 0.1%
Missing	17454
Missing (%)	2.1%
Memory size	6.4 MiB

N	193869
S	187982
W	171319
E	167737
UNKNOWN	63857
Other values (4)	35548

Common Values
Length

Value	Count	Frequency (%)
N	193869	23.1%
S	187982	22.4%
W	171319	20.4%
E	167737	20.0%
UNKNOWN	63857	7.6%
SE	10419	1.2%
NW	9461	1.1%
SW	7846	0.9%
NE	7822	0.9%
(Missing)	17454	2.1%

Length

Max length	7
Median length	1
Mean length	1.541437585
Min length	1

MANEUVER
Categorical

MISSING

Distinct count	28
Unique (%)	< 0.1%
Missing	17454
Missing (%)	2.1%
Memory size	6.4 MiB

STRAIGHT AHEAD	370161
PARKED	106848
SLOW/STOP IN TRAFFIC	66598
UNKNOWN/NA	62754
TURNING LEFT	47399
Other values (23)	166552

Common Values
Length

Value	Count	Frequency (%)
STRAIGHT AHEAD	370161	44.2%
PARKED	106848	12.8%
SLOW/STOP IN TRAFFIC	66598	7.9%
UNKNOWN/NA	62754	7.5%
TURNING LEFT	47399	5.7%
BACKING	35864	4.3%
TURNING RIGHT	27576	3.3%
PASSING/OVERTAKING	19710	2.4%
CHANGING LANES	17481	2.1%
OTHER	13582	1.6%
Other values (18)	52339	6.2%
(Missing)	17454	2.1%

Length

Max length	34
Median length	14
Mean length	12.88169608
Min length	3

TOWED_I
Boolean

MISSING

Distinct count	2
Unique (%)	< 0.1%
Missing	749549
Missing (%)	89.5%
Memory size	6.4 MiB

Y	82735
N	5482
(Missing)	749549

Frequency Table

Value	Count	Frequency (%)
Y	82735	9.9%
N	5482	0.7%
(Missing)	749549	89.5%

FIRE_I
Boolean

MISSING

Distinct count	2
Unique (%)	0.4%
Missing	837249
Missing (%)	99.9%
Memory size	6.4 MiB

Y	287
N	230
(Missing)	837249

Frequency Table

Value	Count	Frequency (%)
Y	287	< 0.1%
N	230	< 0.1%
(Missing)	837249	99.9%

OCCUPANT_CNT
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING
ZEROS

Distinct count	42
Unique (%)	< 0.1%
Missing	17454
Missing (%)	2.1%
Infinite	0
Infinite (%)	0.0%

Mean	1.0935912189508383
Minimum	0.0
Maximum	60.0
Zeros	102317
Zeros (%)	12.2%
Memory size	6.4 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	1
Q3	1
95-th percentile	2
Maximum	60
Range	60
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.7918176361
Coefficient of variation (CV)	0.7240526647
Kurtosis	211.9485143
Mean	1.093591219
Median Absolute Deviation (MAD)	0
Skewness	6.606486737
Sum	897086
Variance	0.6269751689

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1	598078	71.4%
0	102317	12.2%
2	83574	10.0%
3	22750	2.7%
4	9099	1.1%
5	2975	0.4%
6	789	0.1%
7	304	< 0.1%
8	123	< 0.1%
9	68	< 0.1%
Other values (32)	235	< 0.1%
(Missing)	17454	2.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	102317	12.2%
1	598078	71.4%
2	83574	10.0%
3	22750	2.7%
4	9099	1.1%

Value	Count	Frequency (%)
60	1	< 0.1%
47	1	< 0.1%
44	2	< 0.1%
43	1	< 0.1%
41	2	< 0.1%

EXCEED_SPEED_LIMIT_I
Boolean

MISSING

Distinct count	2
Unique (%)	0.1%
Missing	835407
Missing (%)	99.7%
Memory size	6.4 MiB

Y	1774
N	585
(Missing)	835407

Frequency Table

Value	Count	Frequency (%)
Y	1774	0.2%
N	585	0.1%
(Missing)	835407	99.7%

TOWED_BY
Categorical

HIGH CARDINALITY
MISSING

Distinct count	7298
Unique (%)	11.4%
Missing	773923
Missing (%)	92.4%
Memory size	6.4 MiB

PRIVATE TOW	4849
PRIVATE	4847
private	3908
CITY OF CHICAGO	3828
UNKNOWN	3532
Other values (7293)	42879

Common Values
Length

Value	Count	Frequency (%)
PRIVATE TOW	4849	0.6%
PRIVATE	4847	0.6%
private	3908	0.5%
CITY OF CHICAGO	3828	0.5%
UNKNOWN	3532	0.4%
private tow	2909	0.3%
city of chicago	2339	0.3%
UNK	2095	0.3%
unk	2076	0.2%
OWNER	1761	0.2%
Other values (7288)	31699	3.8%
(Missing)	773923	92.4%

Length

Max length	30
Median length	3
Mean length	3.563915222
Min length	1

TOWED_TO
Categorical

HIGH CARDINALITY
MISSING

Distinct count	7702
Unique (%)	19.0%
Missing	797332
Missing (%)	95.2%
Memory size	6.4 MiB

UNKNOWN	6016
UNK	3568
unknown	3368
unk	2942
PRIVATE	633
Other values (7697)	23907

Common Values
Length

Value	Count	Frequency (%)
UNKNOWN	6016	0.7%
UNK	3568	0.4%
unknown	3368	0.4%
unk	2942	0.4%
PRIVATE	633	0.1%
private	566	0.1%
701 N SACRAMENTO	415	< 0.1%
RESIDENCE	364	< 0.1%
POUND 2	343	< 0.1%
POUND	323	< 0.1%
Other values (7692)	21896	2.6%
(Missing)	797332	95.2%

Length

Max length	30
Median length	3
Mean length	3.312754397
Min length	1

AREA_00_I
Boolean

MISSING

Distinct count	2
Unique (%)	< 0.1%
Missing	803547
Missing (%)	95.9%
Memory size	6.4 MiB

Y	29505
N	4714
(Missing)	803547

Frequency Table

Value	Count	Frequency (%)
Y	29505	3.5%
N	4714	0.6%
(Missing)	803547	95.9%

AREA_01_I
Boolean

MISSING

Distinct count	2
Unique (%)	< 0.1%
Missing	621754
Missing (%)	74.2%
Memory size	6.4 MiB

Y	206488
N	9524
(Missing)	621754

Frequency Table

Value	Count	Frequency (%)
Y	206488	24.6%
N	9524	1.1%
(Missing)	621754	74.2%

AREA_02_I
Boolean

MISSING

Distinct count	2
Unique (%)	< 0.1%
Missing	687809
Missing (%)	82.1%
Memory size	6.4 MiB

Y	142604
N	7353
(Missing)	687809

Frequency Table

Value	Count	Frequency (%)
Y	142604	17.0%
N	7353	0.9%
(Missing)	687809	82.1%

AREA_03_I
Boolean

MISSING

Distinct count	2
Unique (%)	< 0.1%
Missing	757701
Missing (%)	90.4%
Memory size	6.4 MiB

Y	76386
N	3679
(Missing)	757701

Frequency Table

Value	Count	Frequency (%)
Y	76386	9.1%
N	3679	0.4%
(Missing)	757701	90.4%

AREA_04_I
Boolean

MISSING

Distinct count	2
Unique (%)	< 0.1%
Missing	751174
Missing (%)	89.7%
Memory size	6.4 MiB

Y	82658
N	3934
(Missing)	751174

Frequency Table

Value	Count	Frequency (%)
Y	82658	9.9%
N	3934	0.5%
(Missing)	751174	89.7%

AREA_05_I
Boolean

MISSING

Distinct count	2
Unique (%)	< 0.1%
Missing	708242
Missing (%)	84.5%
Memory size	6.4 MiB

Y	124694
N	4830
(Missing)	708242

Frequency Table

Value	Count	Frequency (%)
Y	124694	14.9%
N	4830	0.6%
(Missing)	708242	84.5%

AREA_06_I
Boolean

MISSING

Distinct count	2
Unique (%)	< 0.1%
Missing	714831
Missing (%)	85.3%
Memory size	6.4 MiB

Y	117730
N	5205
(Missing)	714831

Frequency Table

Value	Count	Frequency (%)
Y	117730	14.1%
N	5205	0.6%
(Missing)	714831	85.3%

AREA_07_I
Boolean

MISSING

Distinct count	2
Unique (%)	< 0.1%
Missing	734840
Missing (%)	87.7%
Memory size	6.4 MiB

Y	98272
N	4654
(Missing)	734840

Frequency Table

Value	Count	Frequency (%)
Y	98272	11.7%
N	4654	0.6%
(Missing)	734840	87.7%

AREA_08_I
Boolean

MISSING

Distinct count	2
Unique (%)	< 0.1%
Missing	686559
Missing (%)	82.0%
Memory size	6.4 MiB

Y	143118
N	8089
(Missing)	686559

Frequency Table

Value	Count	Frequency (%)
Y	143118	17.1%
N	8089	1.0%
(Missing)	686559	82.0%

AREA_09_I
Boolean

MISSING

Distinct count	2
Unique (%)	< 0.1%
Missing	812559
Missing (%)	97.0%
Memory size	6.4 MiB

Y	23758
N	1449
(Missing)	812559

Frequency Table

Value	Count	Frequency (%)
Y	23758	2.8%
N	1449	0.2%
(Missing)	812559	97.0%

AREA_10_I
Boolean

MISSING

Distinct count	2
Unique (%)	< 0.1%
Missing	800564
Missing (%)	95.6%
Memory size	6.4 MiB

Y	35016
N	2186
(Missing)	800564

Frequency Table

Value	Count	Frequency (%)
Y	35016	4.2%
N	2186	0.3%
(Missing)	800564	95.6%

AREA_11_I
Boolean

MISSING

Distinct count	2
Unique (%)	< 0.1%
Missing	763625
Missing (%)	91.2%
Memory size	6.4 MiB

Y	69167
N	4974
(Missing)	763625

Frequency Table

Value	Count	Frequency (%)
Y	69167	8.3%
N	4974	0.6%
(Missing)	763625	91.2%

AREA_12_I
Boolean

MISSING

Distinct count	2
Unique (%)	< 0.1%
Missing	765460
Missing (%)	91.4%
Memory size	6.4 MiB

Y	69066
N	3240
(Missing)	765460

Frequency Table

Value	Count	Frequency (%)
Y	69066	8.2%
N	3240	0.4%
(Missing)	765460	91.4%

AREA_99_I
Boolean

MISSING

Distinct count	2
Unique (%)	< 0.1%
Missing	751710
Missing (%)	89.7%
Memory size	6.4 MiB

Y	82705
N	3351
(Missing)	751710

Frequency Table

Value	Count	Frequency (%)
Y	82705	9.9%
N	3351	0.4%
(Missing)	751710	89.7%

FIRST_CONTACT_POINT
Categorical

MISSING

Distinct count	14
Unique (%)	< 0.1%
Missing	21456
Missing (%)	2.6%
Memory size	6.4 MiB

FRONT	144611
REAR	96199
FRONT-LEFT	83519
REAR-LEFT	79417
FRONT-RIGHT	77672
Other values (9)	334892

Common Values
Length

Value	Count	Frequency (%)
FRONT	144611	17.3%
REAR	96199	11.5%
FRONT-LEFT	83519	10.0%
REAR-LEFT	79417	9.5%
FRONT-RIGHT	77672	9.3%
UNKNOWN	74864	8.9%
SIDE-LEFT	53293	6.4%
SIDE-RIGHT	53152	6.3%
OTHER	52863	6.3%
REAR-RIGHT	38164	4.6%
Other values (4)	62556	7.5%

Length

Max length	17
Median length	9
Mean length	7.730958287
Min length	3

CMV_ID
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct count	9034
Unique (%)	100.0%
Missing	828732
Missing (%)	98.9%
Infinite	0
Infinite (%)	0.0%

Mean	5060.84868275404
Minimum	1.0
Maximum	10242.0
Zeros	0
Zeros (%)	0.0%
Memory size	6.4 MiB

Quantile statistics

Minimum	1
5-th percentile	505.65
Q1	2494.25
median	4994.5
Q3	7647.75
95-th percentile	9718.35
Maximum	10242
Range	10241
Interquartile range (IQR)	5153.5

Descriptive statistics

Standard deviation	2959.400933
Coefficient of variation (CV)	0.5847637656
Kurtosis	-1.202361292
Mean	5060.848683
Median Absolute Deviation (MAD)	2574
Skewness	0.03839964655
Sum	45719707
Variance	8758053.88

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
8190	1	< 0.1%
6996	1	< 0.1%
2920	1	< 0.1%
3221	1	< 0.1%
805	1	< 0.1%
3219	1	< 0.1%
3218	1	< 0.1%
804	1	< 0.1%
3215	1	< 0.1%
3223	1	< 0.1%
Other values (9024)	9024	1.1%
(Missing)	828732	98.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%

Value	Count	Frequency (%)
10242	1	< 0.1%
10241	1	< 0.1%
10240	1	< 0.1%
10239	1	< 0.1%
10238	1	< 0.1%

USDOT_NO
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	832468
Missing (%)	99.4%
Memory size	6.4 MiB

CCMC_NO
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	836608
Missing (%)	99.9%
Memory size	6.4 MiB

ILCC_NO
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	836909
Missing (%)	99.9%
Memory size	6.4 MiB

COMMERCIAL_SRC
Categorical

MISSING

Distinct count	4
Unique (%)	0.1%
Missing	831185
Missing (%)	99.2%
Memory size	6.4 MiB

SIDE OF TRUCK	2768
DRIVER	2361
PAPERS	972
LOG BOOK	480

Common Values
Length

Value	Count	Frequency (%)
SIDE OF TRUCK	2768	0.3%
DRIVER	2361	0.3%
PAPERS	972	0.1%
LOG BOOK	480	0.1%
(Missing)	831185	99.2%

Length

Max length	13
Median length	3
Mean length	3.047840328
Min length	3

GVWR
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	832521
Missing (%)	99.4%
Memory size	6.4 MiB

CARRIER_NAME
Categorical

HIGH CARDINALITY
MISSING

Distinct count	5945
Unique (%)	68.6%
Missing	829095
Missing (%)	99.0%
Memory size	6.4 MiB

CHICAGO TRANSIT AUTHORITY	309
CTA	189
UNKNOWN	103
JB HUNT	93
CITY OF CHICAGO	65
Other values (5940)	7912

Common Values
Length

Value	Count	Frequency (%)
CHICAGO TRANSIT AUTHORITY	309	< 0.1%
CTA	189	< 0.1%
UNKNOWN	103	< 0.1%
JB HUNT	93	< 0.1%
CITY OF CHICAGO	65	< 0.1%
UNK	46	< 0.1%
JB HUNT TRANSPORT INC	40	< 0.1%
PACE	35	< 0.1%
PACE SUBURBAN BUS DIVISION	33	< 0.1%
PENSKE TRUCK LEASING	30	< 0.1%
Other values (5935)	7728	0.9%
(Missing)	829095	99.0%

Length

Max length	55
Median length	3
Mean length	3.168847864
Min length	2

CARRIER_STATE
Categorical

MISSING

Distinct count	47
Unique (%)	0.6%
Missing	829541
Missing (%)	99.0%
Memory size	6.4 MiB

IL	5191
IN	699
WI	276
TX	157
MI	154
Other values (42)	1748

Common Values
Length

Value	Count	Frequency (%)
IL	5191	0.6%
IN	699	0.1%
WI	276	< 0.1%
TX	157	< 0.1%
MI	154	< 0.1%
OH	139	< 0.1%
IA	132	< 0.1%
PA	117	< 0.1%
AZ	106	< 0.1%
MN	104	< 0.1%
Other values (37)	1150	0.1%
(Missing)	829541	99.0%

Length

Max length	3
Median length	3
Mean length	2.990182223
Min length	2

CARRIER_CITY
Categorical

HIGH CARDINALITY
MISSING

Distinct count	1443
Unique (%)	17.9%
Missing	829690
Missing (%)	99.0%
Memory size	6.4 MiB

CHICAGO	2095
GARY	121
LOWELL	93
INDIANAPOLIS	88
NOBLESVILLE	86
Other values (1438)	5593

Common Values
Length

Value	Count	Frequency (%)
CHICAGO	2095	0.3%
GARY	121	< 0.1%
LOWELL	93	< 0.1%
INDIANAPOLIS	88	< 0.1%
NOBLESVILLE	86	< 0.1%
ARLINGTON HEIGHTS	84	< 0.1%
CICERO	78	< 0.1%
SKOKIE	77	< 0.1%
DES PLAINES	77	< 0.1%
ADDISON	72	< 0.1%
Other values (1433)	5205	0.6%
(Missing)	829690	99.0%

Length

Max length	26
Median length	3
Mean length	3.053433775
Min length	1

HAZMAT_PLACARDS_I
Boolean

MISSING

Distinct count	2
Unique (%)	1.1%
Missing	837586
Missing (%)	> 99.9%
Memory size	6.4 MiB

N	120
Y	60
(Missing)	837586

Frequency Table

Value	Count	Frequency (%)
N	120	< 0.1%
Y	60	< 0.1%
(Missing)	837586	> 99.9%

HAZMAT_NAME
Categorical

MISSING

Distinct count	24
Unique (%)	72.7%
Missing	837733
Missing (%)	> 99.9%
Memory size	6.4 MiB

CORROSIVE	3
FLAMMABLE	3
PROPANE	3
FLAMMABLE LIQUID	2
GASOLINE	2
Other values (19)	20

Common Values
Length

Value	Count	Frequency (%)
CORROSIVE	3	< 0.1%
FLAMMABLE	3	< 0.1%
PROPANE	3	< 0.1%
FLAMMABLE LIQUID	2	< 0.1%
GASOLINE	2	< 0.1%
OXIDIZER	2	< 0.1%
INTEGRAL SLEEPER	1	< 0.1%
OXYGEN LIQUID	1	< 0.1%
FUEL OIL	1	< 0.1%
FLAME	1	< 0.1%
Other values (14)	14	< 0.1%
(Missing)	837733	> 99.9%

Length

Max length	20
Median length	3
Mean length	3.000284089
Min length	1

UN_NO
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	837430
Missing (%)	> 99.9%
Memory size	6.4 MiB

HAZMAT_PRESENT_I
Categorical

MISSING

Distinct count	3
Unique (%)	< 0.1%
Missing	831130
Missing (%)	99.2%
Memory size	6.4 MiB

N	6223
U	400
Y	13

Common Values
Length

Value	Count	Frequency (%)
N	6223	0.7%
U	400	< 0.1%
Y	13	< 0.1%
(Missing)	831130	99.2%

Length

Max length	3
Median length	3
Mean length	2.984157867
Min length	1

HAZMAT_REPORT_I
Categorical

MISSING

Distinct count	3
Unique (%)	< 0.1%
Missing	831337
Missing (%)	99.2%
Memory size	6.4 MiB

N	5610
U	811
Y	8

Common Values
Length

Value	Count	Frequency (%)
N	5610	0.7%
U	811	0.1%
Y	8	< 0.1%
(Missing)	831337	99.2%

Length

Max length	3
Median length	3
Mean length	2.984652039
Min length	1

HAZMAT_REPORT_NO
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	837766
Missing (%)	100.0%
Memory size	6.4 MiB

MCS_REPORT_I
Categorical

MISSING

Distinct count	3
Unique (%)	< 0.1%
Missing	831288
Missing (%)	99.2%
Memory size	6.4 MiB

N	5196
U	1274
Y	8

Common Values
Length

Value	Count	Frequency (%)
N	5196	0.6%
U	1274	0.2%
Y	8	< 0.1%
(Missing)	831288	99.2%

Length

Max length	3
Median length	3
Mean length	2.984535061
Min length	1

MCS_REPORT_NO
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	837761
Missing (%)	> 99.9%
Memory size	6.4 MiB

HAZMAT_VIO_CAUSE_CRASH_I
Categorical

MISSING

Distinct count	3
Unique (%)	< 0.1%
Missing	831236
Missing (%)	99.2%
Memory size	6.4 MiB

N	6039
U	484
Y	7

Common Values
Length

Value	Count	Frequency (%)
N	6039	0.7%
U	484	0.1%
Y	7	< 0.1%
(Missing)	831236	99.2%

Length

Max length	3
Median length	3
Mean length	2.984410921
Min length	1

MCS_VIO_CAUSE_CRASH_I
Categorical

MISSING

Distinct count	3
Unique (%)	< 0.1%
Missing	831330
Missing (%)	99.2%
Memory size	6.4 MiB

N	5410
U	1013
Y	13

Common Values
Length

Value	Count	Frequency (%)
N	5410	0.6%
U	1013	0.1%
Y	13	< 0.1%
(Missing)	831330	99.2%

Length

Max length	3
Median length	3
Mean length	2.984635328
Min length	1

IDOT_PERMIT_NO
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	837227
Missing (%)	99.9%
Memory size	6.4 MiB

WIDE_LOAD_I
Boolean

MISSING

Distinct count	2
Unique (%)	2.7%
Missing	837692
Missing (%)	> 99.9%
Memory size	6.4 MiB

Y	46
N	28
(Missing)	837692

Frequency Table

Value	Count	Frequency (%)
Y	46	< 0.1%
N	28	< 0.1%
(Missing)	837692	> 99.9%

TRAILER1_WIDTH
Categorical

MISSING

Distinct count	3
Unique (%)	0.2%
Missing	835808
Missing (%)	99.8%
Memory size	6.4 MiB

0-96	1299
97-102	397
>102	262

Common Values
Length

Value	Count	Frequency (%)
0-96	1299	0.2%
97-102	397	< 0.1%
>102	262	< 0.1%
(Missing)	835808	99.8%

Length

Max length	6
Median length	3
Mean length	3.003284927
Min length	3

TRAILER2_WIDTH
Categorical

MISSING

Distinct count	3
Unique (%)	1.4%
Missing	837544
Missing (%)	> 99.9%
Memory size	6.4 MiB

0-96	138
>102	46
97-102	38

Common Values
Length

Value	Count	Frequency (%)
0-96	138	< 0.1%
>102	46	< 0.1%
97-102	38	< 0.1%
(Missing)	837544	> 99.9%

Length

Max length	6
Median length	3
Mean length	3.000355708
Min length	3

TRAILER1_LENGTH
Real number (ℝ_≥0)

MISSING

Distinct count	76
Unique (%)	4.7%
Missing	836152
Missing (%)	99.8%
Infinite	0
Infinite (%)	0.0%

Mean	47.84634448574969
Minimum	1.0
Maximum	200.0
Zeros	0
Zeros (%)	0.0%
Memory size	6.4 MiB

Quantile statistics

Minimum	1
5-th percentile	20
Q1	40.25
median	53
Q3	53
95-th percentile	60
Maximum	200
Range	199
Interquartile range (IQR)	12.75

Descriptive statistics

Standard deviation	16.00437582
Coefficient of variation (CV)	0.3344952681
Kurtosis	8.200729415
Mean	47.84634449
Median Absolute Deviation (MAD)	0
Skewness	0.835641432
Sum	77224
Variance	256.1400455

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
53	865	0.1%
48	95	< 0.1%
40	90	< 0.1%
30	52	< 0.1%
20	40	< 0.1%
50	36	< 0.1%
52	32	< 0.1%
45	26	< 0.1%
28	23	< 0.1%
25	23	< 0.1%
Other values (66)	332	< 0.1%
(Missing)	836152	99.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	6	< 0.1%
4	1	< 0.1%
6	6	< 0.1%
7	1	< 0.1%
8	2	< 0.1%

Value	Count	Frequency (%)
200	1	< 0.1%
125	1	< 0.1%
120	3	< 0.1%
115	4	< 0.1%
114	1	< 0.1%

TRAILER2_LENGTH
Real number (ℝ_≥0)

MISSING

Distinct count	28
Unique (%)	62.2%
Missing	837721
Missing (%)	> 99.9%
Infinite	0
Infinite (%)	0.0%

Mean	43.888888888888886
Minimum	2.0
Maximum	120.0
Zeros	0
Zeros (%)	0.0%
Memory size	6.4 MiB

Quantile statistics

Minimum	2
5-th percentile	8.4
Q1	24
median	45
Q3	53
95-th percentile	96
Maximum	120
Range	118
Interquartile range (IQR)	29

Descriptive statistics

Standard deviation	28.544401
Coefficient of variation (CV)	0.6503787569
Kurtosis	0.1429226276
Mean	43.88888889
Median Absolute Deviation (MAD)	18
Skewness	0.7334259495
Sum	1975
Variance	814.7828283

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
53	9	< 0.1%
25	3	< 0.1%
96	3	< 0.1%
48	2	< 0.1%
12	2	< 0.1%
60	2	< 0.1%
14	2	< 0.1%
40	2	< 0.1%
50	1	< 0.1%
43	1	< 0.1%
Other values (18)	18	< 0.1%
(Missing)	837721	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2	1	< 0.1%
3	1	< 0.1%
8	1	< 0.1%
10	1	< 0.1%
12	2	< 0.1%

Value	Count	Frequency (%)
120	1	< 0.1%
99	1	< 0.1%
96	3	< 0.1%
90	1	< 0.1%
73	1	< 0.1%

TOTAL_VEHICLE_LENGTH
Real number (ℝ_≥0)

MISSING

Distinct count	109
Unique (%)	5.6%
Missing	835813
Missing (%)	99.8%
Infinite	0
Infinite (%)	0.0%

Mean	52.26011264720942
Minimum	1.0
Maximum	535.0
Zeros	0
Zeros (%)	0.0%
Memory size	6.4 MiB

Quantile statistics

Minimum	1
5-th percentile	17
Q1	32
median	53
Q3	65
95-th percentile	80
Maximum	535
Range	534
Interquartile range (IQR)	33

Descriptive statistics

Standard deviation	26.97302332
Coefficient of variation (CV)	0.5161302178
Kurtosis	61.01328285
Mean	52.26011265
Median Absolute Deviation (MAD)	15
Skewness	4.306772191
Sum	102064
Variance	727.5439871

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
65	182	< 0.1%
53	161	< 0.1%
40	137	< 0.1%
75	122	< 0.1%
60	109	< 0.1%
63	97	< 0.1%
70	91	< 0.1%
30	75	< 0.1%
20	74	< 0.1%
68	67	< 0.1%
Other values (99)	838	0.1%
(Missing)	835813	99.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	2	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	4	< 0.1%
7	2	< 0.1%

Value	Count	Frequency (%)
535	1	< 0.1%
305	1	< 0.1%
265	1	< 0.1%
245	2	< 0.1%
196	1	< 0.1%

AXLE_CNT
Real number (ℝ_≥0)

MISSING
SKEWED

Distinct count	17
Unique (%)	0.6%
Missing	835049
Missing (%)	99.7%
Infinite	0
Infinite (%)	0.0%

Mean	13.324622745675377
Minimum	1.0
Maximum	26009.0
Zeros	0
Zeros (%)	0.0%
Memory size	6.4 MiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	2
median	3
Q3	5
95-th percentile	6
Maximum	26009
Range	26008
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	498.9121958
Coefficient of variation (CV)	37.44287589
Kurtosis	2716.800551
Mean	13.32462275
Median Absolute Deviation (MAD)	1
Skewness	52.12198557
Sum	36203
Variance	248913.3791

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
5	848	0.1%
2	834	0.1%
3	620	0.1%
6	206	< 0.1%
4	133	< 0.1%
1	33	< 0.1%
8	15	< 0.1%
7	10	< 0.1%
18	5	< 0.1%
16	4	< 0.1%
Other values (7)	9	< 0.1%
(Missing)	835049	99.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	33	< 0.1%
2	834	0.1%
3	620	0.1%
4	133	< 0.1%
5	848	0.1%

Value	Count	Frequency (%)
26009	1	< 0.1%
99	1	< 0.1%
77	1	< 0.1%
55	1	< 0.1%
18	5	< 0.1%

VEHICLE_CONFIG
Categorical

MISSING

Distinct count	8
Unique (%)	0.1%
Missing	830224
Missing (%)	99.1%
Memory size	6.4 MiB

TRACTOR/SEMI-TRAILER	2910
SINGLE UNIT TRUCK, 2 AXLES, 6 TIRES	1504
BUS	1257
TRUCK/TRACTOR	622
TRUCK/TRAILER	506
Other values (3)	743

Common Values
Length

Value	Count	Frequency (%)
TRACTOR/SEMI-TRAILER	2910	0.3%
SINGLE UNIT TRUCK, 2 AXLES, 6 TIRES	1504	0.2%
BUS	1257	0.2%
TRUCK/TRACTOR	622	0.1%
TRUCK/TRAILER	506	0.1%
UNKNOWN HEAVY TRUCK	394	< 0.1%
SINGLE UNIT TRUCK, 3 OR MORE AXLES	328	< 0.1%
TRACTOR/DOUBLES	21	< 0.1%
(Missing)	830224	99.1%

Length

Max length	35
Median length	3
Mean length	3.149924919
Min length	3

CARGO_BODY_TYPE
Categorical

MISSING

Distinct count	9
Unique (%)	0.1%
Missing	830540
Missing (%)	99.1%
Memory size	6.4 MiB

VAN/ENCLOSED BOX	3189
OTHER	1546
BUS	1214
FLATBED	549
DUMP	267
Other values (4)	461

Common Values
Length

Value	Count	Frequency (%)
VAN/ENCLOSED BOX	3189	0.4%
OTHER	1546	0.2%
BUS	1214	0.1%
FLATBED	549	0.1%
DUMP	267	< 0.1%
GARBAGE/REFUSE	178	< 0.1%
TANK	146	< 0.1%
AUTO TRANSPORTER	70	< 0.1%
CONCRETE MIXER	67	< 0.1%
(Missing)	830540	99.1%

Length

Max length	16
Median length	3
Mean length	3.060593292
Min length	3

LOAD_TYPE
Categorical

MISSING

Distinct count	6
Unique (%)	0.1%
Missing	830854
Missing (%)	99.2%
Memory size	6.4 MiB

OTHER	3957
UNKNOWN	2529
CONSTRUCTION EQUIPMENT	238
BUILDING MATERIALS	144
STEEL COILS	34

Common Values
Length

Value	Count	Frequency (%)
OTHER	3957	0.5%
UNKNOWN	2529	0.3%
CONSTRUCTION EQUIPMENT	238	< 0.1%
BUILDING MATERIALS	144	< 0.1%
STEEL COILS	34	< 0.1%
FARM EQUIPMENT	10	< 0.1%
(Missing)	830854	99.2%

Length

Max length	22
Median length	3
Mean length	3.029953471
Min length	3

HAZMAT_OUT_OF_SERVICE_I
Boolean

MISSING

Distinct count	2
Unique (%)	< 0.1%
Missing	831529
Missing (%)	99.3%
Memory size	6.4 MiB

N	6228
Y	9
(Missing)	831529

Frequency Table

Value	Count	Frequency (%)
N	6228	0.7%
Y	9	< 0.1%
(Missing)	831529	99.3%

MCS_OUT_OF_SERVICE_I
Boolean

MISSING

Distinct count	2
Unique (%)	< 0.1%
Missing	831353
Missing (%)	99.2%
Memory size	6.4 MiB

N	6381
Y	32
(Missing)	831353

Frequency Table

Value	Count	Frequency (%)
N	6381	0.8%
Y	32	< 0.1%
(Missing)	831353	99.2%

HAZMAT_CLASS
Categorical

MISSING

Distinct count	8
Unique (%)	1.3%
Missing	837151
Missing (%)	99.9%
Memory size	6.4 MiB

MISCELLANEOUS	527
FLAMMABLE OR COMBUSTIBLE LIQUID	40
GASES	16
EXPLOSIVES	16
CORROSIVE	11
Other values (3)	5

Common Values
Length

Value	Count	Frequency (%)
MISCELLANEOUS	527	0.1%
FLAMMABLE OR COMBUSTIBLE LIQUID	40	< 0.1%
GASES	16	< 0.1%
EXPLOSIVES	16	< 0.1%
CORROSIVE	11	< 0.1%
FLAMMABLE SOLID, SPONTANEOUSLY COMBUSTIBLE, OR DANGEROUS WHEN WET	2	< 0.1%
OXIDIZER OR ORGANIC PEROXIDE	2	< 0.1%
POISON (TOXIC) OR POISON INHALATION HAZARD	1	< 0.1%
(Missing)	837151	99.9%

Length

Max length	65
Median length	3
Mean length	3.008132342
Min length	3

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

First rows

	CRASH_UNIT_ID	CRASH_RECORD_ID	RD_NO	CRASH_DATE	UNIT_NO	UNIT_TYPE	NUM_PASSENGERS	VEHICLE_ID	CMRC_VEH_I	MAKE	MODEL	LIC_PLATE_STATE	VEHICLE_YEAR	VEHICLE_DEFECT	VEHICLE_TYPE	VEHICLE_USE	TRAVEL_DIRECTION	MANEUVER	TOWED_I	FIRE_I	OCCUPANT_CNT	EXCEED_SPEED_LIMIT_I	TOWED_BY	TOWED_TO	AREA_00_I	AREA_01_I	AREA_02_I	AREA_03_I	AREA_04_I	AREA_05_I	AREA_06_I	AREA_07_I	AREA_08_I	AREA_09_I	AREA_10_I	AREA_11_I	AREA_12_I	AREA_99_I	FIRST_CONTACT_POINT	CMV_ID	USDOT_NO	CCMC_NO	ILCC_NO	COMMERCIAL_SRC	GVWR	CARRIER_NAME	CARRIER_STATE	CARRIER_CITY	HAZMAT_PLACARDS_I	HAZMAT_NAME	UN_NO	HAZMAT_PRESENT_I	HAZMAT_REPORT_I	HAZMAT_REPORT_NO	MCS_REPORT_I	MCS_REPORT_NO	HAZMAT_VIO_CAUSE_CRASH_I	MCS_VIO_CAUSE_CRASH_I	IDOT_PERMIT_NO	WIDE_LOAD_I	TRAILER1_WIDTH	TRAILER2_WIDTH	TRAILER1_LENGTH	TRAILER2_LENGTH	TOTAL_VEHICLE_LENGTH	AXLE_CNT	VEHICLE_CONFIG	CARGO_BODY_TYPE	LOAD_TYPE	HAZMAT_OUT_OF_SERVICE_I	MCS_OUT_OF_SERVICE_I	HAZMAT_CLASS
0	10	2e31858c0e411f0bdcb337fb7c415aa93763cf2f23e02fb278e2ed4cf855d36c5a83f270e6f2e0e234ec48b4a0e55a2c51e37b0d40677392c25079c51727a57f	HY368708	08/04/2015 12:40:00 PM	1	DRIVER	NaN	10.0	NaN	FORD	Focus	IL	2001.0	NONE	PASSENGER	PERSONAL	N	TURNING LEFT	NaN	NaN	1.0	NaN	NaN	NaN	N	Y	Y	NaN	NaN	NaN	NaN	NaN	Y	NaN	NaN	NaN	NaN	NaN	FRONT	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
1	100	e73b35bd7651b0c6693162bee0666db159b2890143700936741e9ad9cfc1b0d7f71c0f63dc0594ecdd6fd2183fa2dcd67dfa76a4799839a00a81bc45e3966bb1	HY374018	07/31/2015 05:50:00 PM	1	DRIVER	NaN	96.0	NaN	NISSAN	Pathfinder	IL	1999.0	NONE	SPORT UTILITY VEHICLE (SUV)	PERSONAL	E	STRAIGHT AHEAD	NaN	NaN	1.0	NaN	NaN	NaN	NaN	Y	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	FRONT	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
2	1000	f2b1adeb85a15112e4fb7db74bff440d6ca53ff7a21e10490081685db85460a53c0f3d52dc0e181e69348053ef3198dccbc24e01df9179e42331bc4345e6f28d	HY407431	09/02/2015 11:45:00 AM	1	DRIVER	NaN	954.0	NaN	FORD	F150	KS	NaN	UNKNOWN	VAN/MINI-VAN	UNKNOWN/NA	W	STRAIGHT AHEAD	NaN	NaN	1.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	Y	FRONT	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
3	10000	15a3e24fce3ce7cd2b02d44013d1a93ff2fbdca80632ecca87150673b21e819bd8649e309f867728fd25a9a9fcb6f0f2c00c42ab6733e4d6945262dbe6c90c0e	HY484148	10/31/2015 09:30:00 PM	2	DRIVER	NaN	9561.0	NaN	HYUNDAI	SONATA	NaN	2011.0	NONE	PASSENGER	PERSONAL	E	SLOW/STOP IN TRAFFIC	NaN	NaN	1.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	REAR	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
4	100000	1d3c178880366c77deaf06b8c3198429112a1c8e8807ed95cea7b44e891a873df5b99852206a32d25fe2ede813c2149f25a43b7d2d3e1cc24b62fa437abd638f	HZ518934	11/16/2016 01:00:00 PM	2	PARKED	NaN	96745.0	NaN	TOYOTA MOTOR COMPANY, LTD.	RAV4 (sport utility)	IL	2001.0	UNKNOWN	SPORT UTILITY VEHICLE (SUV)	NOT IN USE	S	PARKED	NaN	NaN	0.0	NaN	NaN	NaN	N	Y	NaN	NaN	NaN	Y	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	UNKNOWN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
5	100001	2fcefeab458932d8b1b12e103c18c50adc659943cccd4b17fc22124a16b1ba9df582f703cd07e7ba892d00b904c9a9849b7c0b6a39063c00e829a752fe22f206	HZ525619	11/15/2016 05:45:00 PM	1	DRIVER	NaN	96762.0	NaN	UNKNOWN	UNKNOWN	NaN	NaN	UNKNOWN	UNKNOWN/NA	UNKNOWN/NA	UNKNOWN	UNKNOWN/NA	NaN	NaN	1.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	Y	Y	Y	NaN	NaN	NaN	NaN	NaN	SIDE-LEFT	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
6	100002	2fcefeab458932d8b1b12e103c18c50adc659943cccd4b17fc22124a16b1ba9df582f703cd07e7ba892d00b904c9a9849b7c0b6a39063c00e829a752fe22f206	HZ525619	11/15/2016 05:45:00 PM	2	DRIVER	NaN	96754.0	NaN	DODGE	CARAVAN	IL	2012.0	NONE	PASSENGER	PERSONAL	E	STRAIGHT AHEAD	NaN	NaN	1.0	NaN	NaN	NaN	NaN	NaN	Y	Y	Y	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	SIDE-LEFT	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
7	100003	c2f21fd14725cf30d43ae59057e59b2e225c9e62a846e7995a6fbf041a23f4578ac02ec12570a1451580b566e134a1aeccceabfc653a1b9a8ca87d122d2bd3e8	HZ525629	11/22/2016 01:45:00 PM	1	DRIVER	NaN	96757.0	NaN	NISSAN	UNKNOWN	IL	2006.0	NONE	PASSENGER	PERSONAL	N	STRAIGHT AHEAD	NaN	NaN	1.0	NaN	NaN	NaN	NaN	Y	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	FRONT	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
8	100004	c2f21fd14725cf30d43ae59057e59b2e225c9e62a846e7995a6fbf041a23f4578ac02ec12570a1451580b566e134a1aeccceabfc653a1b9a8ca87d122d2bd3e8	HZ525629	11/22/2016 01:45:00 PM	2	DRIVER	NaN	96755.0	NaN	TOYOTA MOTOR COMPANY, LTD.	COROLLA	IL	2008.0	NONE	PASSENGER	PERSONAL	N	SLOW/STOP IN TRAFFIC	NaN	NaN	1.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	Y	NaN	NaN	NaN	REAR	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
9	100005	5bfddf5ec81892bf71c2ba0f807c1ec112fd7ecdecbf3c6abbcea4314d7333fc6a4a058537ee8e97dbbb73019444b810f8aabe493003563d25736a5bd2c278a9	HZ525606	11/19/2016 06:35:00 PM	1	DRIVER	NaN	96759.0	NaN	BUICK	UNKNOWN	IL	2012.0	UNKNOWN	PASSENGER	PERSONAL	N	CHANGING LANES	NaN	NaN	1.0	NaN	NaN	NaN	NaN	NaN	Y	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	FRONT-RIGHT	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN

Last rows

	CRASH_UNIT_ID	CRASH_RECORD_ID	RD_NO	CRASH_DATE	UNIT_NO	UNIT_TYPE	NUM_PASSENGERS	VEHICLE_ID	CMRC_VEH_I	MAKE	MODEL	LIC_PLATE_STATE	VEHICLE_YEAR	VEHICLE_DEFECT	VEHICLE_TYPE	VEHICLE_USE	TRAVEL_DIRECTION	MANEUVER	TOWED_I	FIRE_I	OCCUPANT_CNT	EXCEED_SPEED_LIMIT_I	TOWED_BY	TOWED_TO	AREA_00_I	AREA_01_I	AREA_02_I	AREA_03_I	AREA_04_I	AREA_05_I	AREA_06_I	AREA_07_I	AREA_08_I	AREA_09_I	AREA_10_I	AREA_11_I	AREA_12_I	AREA_99_I	FIRST_CONTACT_POINT	CMV_ID	USDOT_NO	CCMC_NO	ILCC_NO	COMMERCIAL_SRC	GVWR	CARRIER_NAME	CARRIER_STATE	CARRIER_CITY	HAZMAT_PLACARDS_I	HAZMAT_NAME	UN_NO	HAZMAT_PRESENT_I	HAZMAT_REPORT_I	HAZMAT_REPORT_NO	MCS_REPORT_I	MCS_REPORT_NO	HAZMAT_VIO_CAUSE_CRASH_I	MCS_VIO_CAUSE_CRASH_I	IDOT_PERMIT_NO	WIDE_LOAD_I	TRAILER1_WIDTH	TRAILER2_WIDTH	TRAILER1_LENGTH	TRAILER2_LENGTH	TOTAL_VEHICLE_LENGTH	AXLE_CNT	VEHICLE_CONFIG	CARGO_BODY_TYPE	LOAD_TYPE	HAZMAT_OUT_OF_SERVICE_I	MCS_OUT_OF_SERVICE_I	HAZMAT_CLASS
837756	903038	b6b89d3e6f386c124c7bd0ca58c0979e324cd367dc4b6ae1eee837536b137dd74a5a33f4dbfa4d7bf74b54ebca72a26749a8e8967d601bbd51c0dbdcf3d4296a	JD270339	06/16/2020 09:25:00 PM	1	DRIVER	NaN	856268.0	NaN	STERLING	OTHER (EXPLAIN IN NARRATIVE)	IL	2007.0	UNKNOWN	UNKNOWN/NA	UNKNOWN/NA	W	STRAIGHT AHEAD	NaN	NaN	1.0	NaN	NaN	NaN	NaN	Y	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	FRONT	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
837757	903039	b6b89d3e6f386c124c7bd0ca58c0979e324cd367dc4b6ae1eee837536b137dd74a5a33f4dbfa4d7bf74b54ebca72a26749a8e8967d601bbd51c0dbdcf3d4296a	JD270339	06/16/2020 09:25:00 PM	2	PARKED	4.0	856274.0	NaN	FORD	EXPLORER	IL	2004.0	UNKNOWN	SPORT UTILITY VEHICLE (SUV)	UNKNOWN/NA	W	PARKED	NaN	NaN	4.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	Y	NaN	NaN	NaN	NaN	NaN	NaN	FRONT-LEFT	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
837758	903883	5526a4009f96cf49b607eed87ab770599919c08bd03e3b164f738c9318cd54fffb1e3ce1d13a29a5fc5ccf3d86106ea37ece3056b98b88fcfe96db31603ec9b7	JD266343	06/16/2020 07:45:00 PM	1	DRIVER	NaN	857068.0	NaN	CHRYSLER	SEBRING	IL	2002.0	UNKNOWN	PASSENGER	PERSONAL	E	UNKNOWN/NA	Y	NaN	1.0	NaN	e&r	103rd and doty	NaN	Y	Y	NaN	NaN	NaN	NaN	NaN	NaN	NaN	Y	Y	Y	NaN	OTHER	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
837759	903884	5526a4009f96cf49b607eed87ab770599919c08bd03e3b164f738c9318cd54fffb1e3ce1d13a29a5fc5ccf3d86106ea37ece3056b98b88fcfe96db31603ec9b7	JD266343	06/16/2020 07:45:00 PM	2	DRIVER	NaN	857069.0	NaN	NISSAN	ROGUE	IL	2018.0	NONE	PASSENGER	PERSONAL	W	OTHER	NaN	NaN	1.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	Y	NaN	NaN	NaN	NaN	NaN	NaN	SIDE-LEFT	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
837760	904947	f8789485a2c59cc21aaca437a448821a33a42b4be8de6f06f49ba6fa5feef2c01a18bcbf4ccc2d811d77c4867f8d00ec3678f70295f311a696840131f580c115	JD273627	06/16/2020 02:00:00 PM	1	DRIVER	NaN	858084.0	Y	FREIGHTLINER CORPORATION	OTHER (EXPLAIN IN NARRATIVE)	IL	1998.0	UNKNOWN	TRUCK - SINGLE UNIT	COMMERCIAL - SINGLE UNIT	E	TURNING RIGHT	NaN	NaN	1.0	NaN	NaN	NaN	NaN	Y	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	FRONT	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
837761	904948	f8789485a2c59cc21aaca437a448821a33a42b4be8de6f06f49ba6fa5feef2c01a18bcbf4ccc2d811d77c4867f8d00ec3678f70295f311a696840131f580c115	JD273627	06/16/2020 02:00:00 PM	2	DRIVER	NaN	858089.0	NaN	DODGE	RAM 1500 PU	IL	2016.0	NONE	PICKUP	OTHER	E	TURNING RIGHT	NaN	NaN	1.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	Y	NaN	NaN	NaN	NaN	ROOF	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
837762	905072	c7da7a2778969bfebbfa528ce03c975c21412b82fd7b61e8666fd85f6d6f402cb465831ee8e19b57a7eb2fd43c030e1fc20d61d4b0ac5a2df4813aaf1a5815f4	JD273565	06/16/2020 12:30:00 PM	1	DRIVER	NaN	858203.0	NaN	CHRYSLER	OTHER (EXPLAIN IN NARRATIVE)	IL	2007.0	UNKNOWN	PASSENGER	PERSONAL	N	STRAIGHT AHEAD	NaN	NaN	1.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	Y	UNKNOWN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
837763	905073	c7da7a2778969bfebbfa528ce03c975c21412b82fd7b61e8666fd85f6d6f402cb465831ee8e19b57a7eb2fd43c030e1fc20d61d4b0ac5a2df4813aaf1a5815f4	JD273565	06/16/2020 12:30:00 PM	2	DRIVER	NaN	858210.0	NaN	FORD	TAURUS	IL	2012.0	NONE	PASSENGER	PERSONAL	N	STRAIGHT AHEAD	NaN	NaN	1.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	Y	NaN	NaN	NaN	NaN	NaN	NaN	NaN	REAR-LEFT	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
837764	905084	09a93b52a5387fec43780859b3b6539431ec1e8774372dbaecd12b28601b97821b500911dc61dba23259b03d4542f843c2d292a82c6a79aa8ad60e1a1f9cffd6	JD273888	06/16/2020 08:30:00 AM	1	DRIVER	NaN	858212.0	NaN	DODGE	OTHER (EXPLAIN IN NARRATIVE)	IL	2008.0	NONE	PICKUP	UNKNOWN/NA	UNKNOWN	UNKNOWN/NA	NaN	NaN	1.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	Y	UNKNOWN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
837765	905085	09a93b52a5387fec43780859b3b6539431ec1e8774372dbaecd12b28601b97821b500911dc61dba23259b03d4542f843c2d292a82c6a79aa8ad60e1a1f9cffd6	JD273888	06/16/2020 08:30:00 AM	2	PARKED	NaN	858205.0	NaN	HYUNDAI	SONATA	IL	2011.0	NONE	PASSENGER	PERSONAL	E	PARKED	NaN	NaN	0.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	Y	N	NaN	NaN	NaN	NaN	Y	Y	NaN	NaN	FRONT-RIGHT	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Cramér's V (φc)

Missing values

Sample

First rows

Last rows